{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "df6094f5",
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib notebook\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ff97fb4e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2025, 4, 24, 0, 30)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dt = datetime.datetime(year=2025,month=4,day=24,minute=30)\n",
    "dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "11bcdbde",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2025-04-24 00:30:00\n"
     ]
    }
   ],
   "source": [
    "print(dt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "36d8c97f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2025-04-13 00:00:00')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "ts = pd.Timestamp('2025-4-13')\n",
    "ts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "50fe98dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "57fe667d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "13e169f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2025-04-18 00:00:00')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts + pd.Timedelta('5 days')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "8a972b64",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2025-04-18 00:00:00')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.to_datetime('2025-04-18')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7686e00d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2025-04-18 00:00:00')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.to_datetime('2025/04/18')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ef040fd1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    2025-04-12 00:00:00\n",
       "1    2025-04-13 00:00:00\n",
       "2    2025-04-14 00:00:00\n",
       "dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s = pd.Series(['2025-04-12 00:00:00','2025-04-13 00:00:00','2025-04-14 00:00:00'])\n",
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "39105d07",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   2025-04-12\n",
       "1   2025-04-13\n",
       "2   2025-04-14\n",
       "dtype: datetime64[ns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts = pd.to_datetime(s)\n",
    "ts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d6f79ff3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    0\n",
       "1    0\n",
       "2    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.dt.hour"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "67e15e70",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    5\n",
       "1    6\n",
       "2    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.dt.weekday"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "50a1a8f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   2025-04-13 00:00:00\n",
       "1   2025-04-13 12:00:00\n",
       "2   2025-04-14 00:00:00\n",
       "3   2025-04-14 12:00:00\n",
       "4   2025-04-15 00:00:00\n",
       "5   2025-04-15 12:00:00\n",
       "6   2025-04-16 00:00:00\n",
       "7   2025-04-16 12:00:00\n",
       "8   2025-04-17 00:00:00\n",
       "9   2025-04-17 12:00:00\n",
       "dtype: datetime64[ns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.Series(pd.date_range(start='2025-04-13',periods=10,freq='12H'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "20262a2d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Datetime</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-10-16 06:00:00+00:00</td>\n",
       "      <td>60.455</td>\n",
       "      <td>60.462</td>\n",
       "      <td>55.855</td>\n",
       "      <td>57.399</td>\n",
       "      <td>209442.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-10-16 06:30:00+00:00</td>\n",
       "      <td>57.380</td>\n",
       "      <td>57.800</td>\n",
       "      <td>49.301</td>\n",
       "      <td>50.851</td>\n",
       "      <td>246801.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-10-16 07:00:00+00:00</td>\n",
       "      <td>50.900</td>\n",
       "      <td>51.840</td>\n",
       "      <td>48.100</td>\n",
       "      <td>50.120</td>\n",
       "      <td>194861.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-10-16 07:30:00+00:00</td>\n",
       "      <td>50.120</td>\n",
       "      <td>50.299</td>\n",
       "      <td>48.200</td>\n",
       "      <td>48.850</td>\n",
       "      <td>124877.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-10-16 08:00:00+00:00</td>\n",
       "      <td>48.850</td>\n",
       "      <td>49.245</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.673</td>\n",
       "      <td>136598.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Datetime    Open    High     Low   Close    Volume\n",
       "0  2020-10-16 06:00:00+00:00  60.455  60.462  55.855  57.399  209442.2\n",
       "1  2020-10-16 06:30:00+00:00  57.380  57.800  49.301  50.851  246801.6\n",
       "2  2020-10-16 07:00:00+00:00  50.900  51.840  48.100  50.120  194861.4\n",
       "3  2020-10-16 07:30:00+00:00  50.120  50.299  48.200  48.850  124877.4\n",
       "4  2020-10-16 08:00:00+00:00  48.850  49.245  47.200  47.673  136598.9"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('./data/FIL_30m_klines.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "637e8623",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 06:00:00+00:00</th>\n",
       "      <td>60.455</td>\n",
       "      <td>60.462</td>\n",
       "      <td>55.855</td>\n",
       "      <td>57.399</td>\n",
       "      <td>209442.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 06:30:00+00:00</th>\n",
       "      <td>57.380</td>\n",
       "      <td>57.800</td>\n",
       "      <td>49.301</td>\n",
       "      <td>50.851</td>\n",
       "      <td>246801.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 07:00:00+00:00</th>\n",
       "      <td>50.900</td>\n",
       "      <td>51.840</td>\n",
       "      <td>48.100</td>\n",
       "      <td>50.120</td>\n",
       "      <td>194861.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 07:30:00+00:00</th>\n",
       "      <td>50.120</td>\n",
       "      <td>50.299</td>\n",
       "      <td>48.200</td>\n",
       "      <td>48.850</td>\n",
       "      <td>124877.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 08:00:00+00:00</th>\n",
       "      <td>48.850</td>\n",
       "      <td>49.245</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.673</td>\n",
       "      <td>136598.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41621 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close     Volume\n",
       "Datetime                                                            \n",
       "2020-10-16 06:00:00+00:00  60.455  60.462  55.855  57.399   209442.2\n",
       "2020-10-16 06:30:00+00:00  57.380  57.800  49.301  50.851   246801.6\n",
       "2020-10-16 07:00:00+00:00  50.900  51.840  48.100  50.120   194861.4\n",
       "2020-10-16 07:30:00+00:00  50.120  50.299  48.200  48.850   124877.4\n",
       "2020-10-16 08:00:00+00:00  48.850  49.245  47.200  47.673   136598.9\n",
       "...                           ...     ...     ...     ...        ...\n",
       "2023-03-02 06:00:00+00:00   6.899   6.921   6.829   6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00   6.916   6.932   6.880   6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00   6.900   6.938   6.881   6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00   6.902   6.920   6.882   6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00   6.916   6.930   6.886   6.903   414231.8\n",
       "\n",
       "[41621 rows x 5 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Datetime'] =pd.to_datetime(data['Datetime'])\n",
    "data = data.set_index('Datetime')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "e8b725d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2020-10-16 06:00:00+00:00', '2020-10-16 06:30:00+00:00',\n",
       "               '2020-10-16 07:00:00+00:00', '2020-10-16 07:30:00+00:00',\n",
       "               '2020-10-16 08:00:00+00:00', '2020-10-16 08:30:00+00:00',\n",
       "               '2020-10-16 09:00:00+00:00', '2020-10-16 09:30:00+00:00',\n",
       "               '2020-10-16 10:00:00+00:00', '2020-10-16 10:30:00+00:00',\n",
       "               ...\n",
       "               '2023-03-02 03:30:00+00:00', '2023-03-02 04:00:00+00:00',\n",
       "               '2023-03-02 04:30:00+00:00', '2023-03-02 05:00:00+00:00',\n",
       "               '2023-03-02 05:30:00+00:00', '2023-03-02 06:00:00+00:00',\n",
       "               '2023-03-02 06:30:00+00:00', '2023-03-02 07:00:00+00:00',\n",
       "               '2023-03-02 07:30:00+00:00', '2023-03-02 08:00:00+00:00'],\n",
       "              dtype='datetime64[ns, UTC]', name='Datetime', length=41621, freq=None)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "46b8ac06",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 06:00:00+00:00</th>\n",
       "      <td>60.455</td>\n",
       "      <td>60.462</td>\n",
       "      <td>55.855</td>\n",
       "      <td>57.399</td>\n",
       "      <td>209442.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 06:30:00+00:00</th>\n",
       "      <td>57.380</td>\n",
       "      <td>57.800</td>\n",
       "      <td>49.301</td>\n",
       "      <td>50.851</td>\n",
       "      <td>246801.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 07:00:00+00:00</th>\n",
       "      <td>50.900</td>\n",
       "      <td>51.840</td>\n",
       "      <td>48.100</td>\n",
       "      <td>50.120</td>\n",
       "      <td>194861.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 07:30:00+00:00</th>\n",
       "      <td>50.120</td>\n",
       "      <td>50.299</td>\n",
       "      <td>48.200</td>\n",
       "      <td>48.850</td>\n",
       "      <td>124877.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 08:00:00+00:00</th>\n",
       "      <td>48.850</td>\n",
       "      <td>49.245</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.673</td>\n",
       "      <td>136598.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41621 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close     Volume\n",
       "Datetime                                                            \n",
       "2020-10-16 06:00:00+00:00  60.455  60.462  55.855  57.399   209442.2\n",
       "2020-10-16 06:30:00+00:00  57.380  57.800  49.301  50.851   246801.6\n",
       "2020-10-16 07:00:00+00:00  50.900  51.840  48.100  50.120   194861.4\n",
       "2020-10-16 07:30:00+00:00  50.120  50.299  48.200  48.850   124877.4\n",
       "2020-10-16 08:00:00+00:00  48.850  49.245  47.200  47.673   136598.9\n",
       "...                           ...     ...     ...     ...        ...\n",
       "2023-03-02 06:00:00+00:00   6.899   6.921   6.829   6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00   6.916   6.932   6.880   6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00   6.900   6.938   6.881   6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00   6.902   6.920   6.882   6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00   6.916   6.930   6.886   6.903   414231.8\n",
       "\n",
       "[41621 rows x 5 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('./data/FIL_30m_klines.csv',index_col=0,parse_dates =True)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "6e503cdb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\MI\\AppData\\Local\\Temp\\ipykernel_17984\\2090852376.py:1: FutureWarning: Indexing a timezone-aware DatetimeIndex with a timezone-naive datetime is deprecated and will raise KeyError in a future version. Use a timezone-aware object instead.\n",
      "  data[pd.Timestamp('2023-03-02 06:00'):pd.Timestamp('2023-03-02 14:00')]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Open   High    Low  Close     Volume\n",
       "Datetime                                                        \n",
       "2023-03-02 06:00:00+00:00  6.899  6.921  6.829  6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00  6.916  6.932  6.880  6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00  6.900  6.938  6.881  6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00  6.902  6.920  6.882  6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00  6.916  6.930  6.886  6.903   414231.8"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[pd.Timestamp('2023-03-02 06:00'):pd.Timestamp('2023-03-02 14:00')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "d4e60cda",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\MI\\AppData\\Local\\Temp\\ipykernel_17984\\3428297312.py:1: FutureWarning: Indexing a timezone-aware DatetimeIndex with a timezone-naive datetime is deprecated and will raise KeyError in a future version. Use a timezone-aware object instead.\n",
      "  data[('2023-03-02 06:00'):pd.Timestamp('2023-03-02 14:00')]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Open   High    Low  Close     Volume\n",
       "Datetime                                                        \n",
       "2023-03-02 06:00:00+00:00  6.899  6.921  6.829  6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00  6.916  6.932  6.880  6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00  6.900  6.938  6.881  6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00  6.902  6.920  6.882  6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00  6.916  6.930  6.886  6.903   414231.8"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[('2023-03-02 06:00'):pd.Timestamp('2023-03-02 14:00')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "3a30194f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-03-02 03:30:00+00:00</th>\n",
       "      <td>6.976</td>\n",
       "      <td>6.979</td>\n",
       "      <td>6.926</td>\n",
       "      <td>6.952</td>\n",
       "      <td>726287.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 04:00:00+00:00</th>\n",
       "      <td>6.952</td>\n",
       "      <td>6.989</td>\n",
       "      <td>6.951</td>\n",
       "      <td>6.985</td>\n",
       "      <td>683236.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 04:30:00+00:00</th>\n",
       "      <td>6.986</td>\n",
       "      <td>7.015</td>\n",
       "      <td>6.978</td>\n",
       "      <td>7.009</td>\n",
       "      <td>756444.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 05:00:00+00:00</th>\n",
       "      <td>7.008</td>\n",
       "      <td>7.010</td>\n",
       "      <td>6.925</td>\n",
       "      <td>6.932</td>\n",
       "      <td>889398.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 05:30:00+00:00</th>\n",
       "      <td>6.933</td>\n",
       "      <td>6.953</td>\n",
       "      <td>6.855</td>\n",
       "      <td>6.899</td>\n",
       "      <td>2023033.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Open   High    Low  Close     Volume\n",
       "Datetime                                                        \n",
       "2023-03-02 03:30:00+00:00  6.976  6.979  6.926  6.952   726287.5\n",
       "2023-03-02 04:00:00+00:00  6.952  6.989  6.951  6.985   683236.8\n",
       "2023-03-02 04:30:00+00:00  6.986  7.015  6.978  7.009   756444.7\n",
       "2023-03-02 05:00:00+00:00  7.008  7.010  6.925  6.932   889398.2\n",
       "2023-03-02 05:30:00+00:00  6.933  6.953  6.855  6.899  2023033.1\n",
       "2023-03-02 06:00:00+00:00  6.899  6.921  6.829  6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00  6.916  6.932  6.880  6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00  6.900  6.938  6.881  6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00  6.902  6.920  6.882  6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00  6.916  6.930  6.886  6.903   414231.8"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3d2ffda9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-03-01 00:00:00+00:00</th>\n",
       "      <td>6.483</td>\n",
       "      <td>6.508</td>\n",
       "      <td>6.428</td>\n",
       "      <td>6.499</td>\n",
       "      <td>1143455.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 00:30:00+00:00</th>\n",
       "      <td>6.498</td>\n",
       "      <td>6.522</td>\n",
       "      <td>6.406</td>\n",
       "      <td>6.441</td>\n",
       "      <td>1206404.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 01:00:00+00:00</th>\n",
       "      <td>6.441</td>\n",
       "      <td>6.473</td>\n",
       "      <td>6.429</td>\n",
       "      <td>6.447</td>\n",
       "      <td>705065.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 01:30:00+00:00</th>\n",
       "      <td>6.447</td>\n",
       "      <td>6.496</td>\n",
       "      <td>6.444</td>\n",
       "      <td>6.479</td>\n",
       "      <td>853576.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 02:00:00+00:00</th>\n",
       "      <td>6.479</td>\n",
       "      <td>6.526</td>\n",
       "      <td>6.465</td>\n",
       "      <td>6.491</td>\n",
       "      <td>873141.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:00:00+00:00</th>\n",
       "      <td>6.899</td>\n",
       "      <td>6.921</td>\n",
       "      <td>6.829</td>\n",
       "      <td>6.916</td>\n",
       "      <td>1729993.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 06:30:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.932</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.900</td>\n",
       "      <td>996422.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:00:00+00:00</th>\n",
       "      <td>6.900</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.881</td>\n",
       "      <td>6.902</td>\n",
       "      <td>1152507.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 07:30:00+00:00</th>\n",
       "      <td>6.902</td>\n",
       "      <td>6.920</td>\n",
       "      <td>6.882</td>\n",
       "      <td>6.916</td>\n",
       "      <td>856132.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Open   High    Low  Close     Volume\n",
       "Datetime                                                        \n",
       "2023-03-01 00:00:00+00:00  6.483  6.508  6.428  6.499  1143455.8\n",
       "2023-03-01 00:30:00+00:00  6.498  6.522  6.406  6.441  1206404.6\n",
       "2023-03-01 01:00:00+00:00  6.441  6.473  6.429  6.447   705065.1\n",
       "2023-03-01 01:30:00+00:00  6.447  6.496  6.444  6.479   853576.6\n",
       "2023-03-01 02:00:00+00:00  6.479  6.526  6.465  6.491   873141.8\n",
       "...                          ...    ...    ...    ...        ...\n",
       "2023-03-02 06:00:00+00:00  6.899  6.921  6.829  6.916  1729993.6\n",
       "2023-03-02 06:30:00+00:00  6.916  6.932  6.880  6.900   996422.2\n",
       "2023-03-02 07:00:00+00:00  6.900  6.938  6.881  6.902  1152507.0\n",
       "2023-03-02 07:30:00+00:00  6.902  6.920  6.882  6.916   856132.2\n",
       "2023-03-02 08:00:00+00:00  6.916  6.930  6.886  6.903   414231.8\n",
       "\n",
       "[65 rows x 5 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['2023-03':'2023-04']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "686cdd04",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>24.357</td>\n",
       "      <td>24.801</td>\n",
       "      <td>23.954</td>\n",
       "      <td>24.240</td>\n",
       "      <td>94292.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:30:00+00:00</th>\n",
       "      <td>24.246</td>\n",
       "      <td>25.012</td>\n",
       "      <td>24.200</td>\n",
       "      <td>25.000</td>\n",
       "      <td>61320.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 01:00:00+00:00</th>\n",
       "      <td>25.001</td>\n",
       "      <td>25.054</td>\n",
       "      <td>24.337</td>\n",
       "      <td>24.537</td>\n",
       "      <td>96901.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 01:30:00+00:00</th>\n",
       "      <td>24.556</td>\n",
       "      <td>24.620</td>\n",
       "      <td>23.858</td>\n",
       "      <td>23.887</td>\n",
       "      <td>83379.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 02:00:00+00:00</th>\n",
       "      <td>23.881</td>\n",
       "      <td>24.479</td>\n",
       "      <td>23.862</td>\n",
       "      <td>24.235</td>\n",
       "      <td>70951.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31 21:30:00+00:00</th>\n",
       "      <td>5.263</td>\n",
       "      <td>5.274</td>\n",
       "      <td>5.193</td>\n",
       "      <td>5.239</td>\n",
       "      <td>719820.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31 22:00:00+00:00</th>\n",
       "      <td>5.239</td>\n",
       "      <td>5.241</td>\n",
       "      <td>5.168</td>\n",
       "      <td>5.170</td>\n",
       "      <td>499412.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31 22:30:00+00:00</th>\n",
       "      <td>5.170</td>\n",
       "      <td>5.267</td>\n",
       "      <td>5.168</td>\n",
       "      <td>5.235</td>\n",
       "      <td>516316.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31 23:00:00+00:00</th>\n",
       "      <td>5.235</td>\n",
       "      <td>5.280</td>\n",
       "      <td>5.218</td>\n",
       "      <td>5.261</td>\n",
       "      <td>664780.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31 23:30:00+00:00</th>\n",
       "      <td>5.261</td>\n",
       "      <td>5.273</td>\n",
       "      <td>5.219</td>\n",
       "      <td>5.233</td>\n",
       "      <td>749564.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4464 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close    Volume\n",
       "Datetime                                                           \n",
       "2021-01-01 00:00:00+00:00  24.357  24.801  23.954  24.240   94292.9\n",
       "2021-01-01 00:30:00+00:00  24.246  25.012  24.200  25.000   61320.4\n",
       "2021-01-01 01:00:00+00:00  25.001  25.054  24.337  24.537   96901.1\n",
       "2021-01-01 01:30:00+00:00  24.556  24.620  23.858  23.887   83379.1\n",
       "2021-01-01 02:00:00+00:00  23.881  24.479  23.862  24.235   70951.6\n",
       "...                           ...     ...     ...     ...       ...\n",
       "2023-01-31 21:30:00+00:00   5.263   5.274   5.193   5.239  719820.2\n",
       "2023-01-31 22:00:00+00:00   5.239   5.241   5.168   5.170  499412.8\n",
       "2023-01-31 22:30:00+00:00   5.170   5.267   5.168   5.235  516316.3\n",
       "2023-01-31 23:00:00+00:00   5.235   5.280   5.218   5.261  664780.1\n",
       "2023-01-31 23:30:00+00:00   5.261   5.273   5.219   5.233  749564.5\n",
       "\n",
       "[4464 rows x 5 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.index.month==1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "cf2c18bb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 09:00:00+00:00</th>\n",
       "      <td>45.961</td>\n",
       "      <td>47.799</td>\n",
       "      <td>45.210</td>\n",
       "      <td>47.484</td>\n",
       "      <td>185581.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 09:30:00+00:00</th>\n",
       "      <td>47.484</td>\n",
       "      <td>48.780</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.855</td>\n",
       "      <td>157664.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 10:00:00+00:00</th>\n",
       "      <td>47.988</td>\n",
       "      <td>49.744</td>\n",
       "      <td>46.668</td>\n",
       "      <td>47.908</td>\n",
       "      <td>164815.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 10:30:00+00:00</th>\n",
       "      <td>47.977</td>\n",
       "      <td>48.268</td>\n",
       "      <td>46.000</td>\n",
       "      <td>46.340</td>\n",
       "      <td>112983.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 11:00:00+00:00</th>\n",
       "      <td>46.334</td>\n",
       "      <td>46.950</td>\n",
       "      <td>43.720</td>\n",
       "      <td>44.972</td>\n",
       "      <td>175209.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 09:30:00+00:00</th>\n",
       "      <td>6.934</td>\n",
       "      <td>6.938</td>\n",
       "      <td>6.880</td>\n",
       "      <td>6.894</td>\n",
       "      <td>1376644.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 10:00:00+00:00</th>\n",
       "      <td>6.895</td>\n",
       "      <td>6.925</td>\n",
       "      <td>6.875</td>\n",
       "      <td>6.912</td>\n",
       "      <td>1000716.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 10:30:00+00:00</th>\n",
       "      <td>6.912</td>\n",
       "      <td>6.963</td>\n",
       "      <td>6.909</td>\n",
       "      <td>6.953</td>\n",
       "      <td>953772.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 11:00:00+00:00</th>\n",
       "      <td>6.953</td>\n",
       "      <td>6.959</td>\n",
       "      <td>6.891</td>\n",
       "      <td>6.912</td>\n",
       "      <td>671234.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 11:30:00+00:00</th>\n",
       "      <td>6.913</td>\n",
       "      <td>6.981</td>\n",
       "      <td>6.900</td>\n",
       "      <td>6.946</td>\n",
       "      <td>832473.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5202 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close     Volume\n",
       "Datetime                                                            \n",
       "2020-10-16 09:00:00+00:00  45.961  47.799  45.210  47.484   185581.7\n",
       "2020-10-16 09:30:00+00:00  47.484  48.780  47.200  47.855   157664.5\n",
       "2020-10-16 10:00:00+00:00  47.988  49.744  46.668  47.908   164815.3\n",
       "2020-10-16 10:30:00+00:00  47.977  48.268  46.000  46.340   112983.1\n",
       "2020-10-16 11:00:00+00:00  46.334  46.950  43.720  44.972   175209.6\n",
       "...                           ...     ...     ...     ...        ...\n",
       "2023-03-01 09:30:00+00:00   6.934   6.938   6.880   6.894  1376644.0\n",
       "2023-03-01 10:00:00+00:00   6.895   6.925   6.875   6.912  1000716.4\n",
       "2023-03-01 10:30:00+00:00   6.912   6.963   6.909   6.953   953772.0\n",
       "2023-03-01 11:00:00+00:00   6.953   6.959   6.891   6.912   671234.7\n",
       "2023-03-01 11:30:00+00:00   6.913   6.981   6.900   6.946   832473.5\n",
       "\n",
       "[5202 rows x 5 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data.index.hour >8) & (data.index.hour <12)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "f3721e72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 08:00:00+00:00</th>\n",
       "      <td>48.850</td>\n",
       "      <td>49.245</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.673</td>\n",
       "      <td>136598.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 08:30:00+00:00</th>\n",
       "      <td>47.754</td>\n",
       "      <td>48.700</td>\n",
       "      <td>45.653</td>\n",
       "      <td>45.974</td>\n",
       "      <td>133478.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 09:00:00+00:00</th>\n",
       "      <td>45.961</td>\n",
       "      <td>47.799</td>\n",
       "      <td>45.210</td>\n",
       "      <td>47.484</td>\n",
       "      <td>185581.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 09:30:00+00:00</th>\n",
       "      <td>47.484</td>\n",
       "      <td>48.780</td>\n",
       "      <td>47.200</td>\n",
       "      <td>47.855</td>\n",
       "      <td>157664.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-16 10:00:00+00:00</th>\n",
       "      <td>47.988</td>\n",
       "      <td>49.744</td>\n",
       "      <td>46.668</td>\n",
       "      <td>47.908</td>\n",
       "      <td>164815.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 10:30:00+00:00</th>\n",
       "      <td>6.912</td>\n",
       "      <td>6.963</td>\n",
       "      <td>6.909</td>\n",
       "      <td>6.953</td>\n",
       "      <td>953772.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 11:00:00+00:00</th>\n",
       "      <td>6.953</td>\n",
       "      <td>6.959</td>\n",
       "      <td>6.891</td>\n",
       "      <td>6.912</td>\n",
       "      <td>671234.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 11:30:00+00:00</th>\n",
       "      <td>6.913</td>\n",
       "      <td>6.981</td>\n",
       "      <td>6.900</td>\n",
       "      <td>6.946</td>\n",
       "      <td>832473.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-01 12:00:00+00:00</th>\n",
       "      <td>6.946</td>\n",
       "      <td>6.976</td>\n",
       "      <td>6.908</td>\n",
       "      <td>6.969</td>\n",
       "      <td>1109056.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-02 08:00:00+00:00</th>\n",
       "      <td>6.916</td>\n",
       "      <td>6.930</td>\n",
       "      <td>6.886</td>\n",
       "      <td>6.903</td>\n",
       "      <td>414231.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7804 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close     Volume\n",
       "Datetime                                                            \n",
       "2020-10-16 08:00:00+00:00  48.850  49.245  47.200  47.673   136598.9\n",
       "2020-10-16 08:30:00+00:00  47.754  48.700  45.653  45.974   133478.1\n",
       "2020-10-16 09:00:00+00:00  45.961  47.799  45.210  47.484   185581.7\n",
       "2020-10-16 09:30:00+00:00  47.484  48.780  47.200  47.855   157664.5\n",
       "2020-10-16 10:00:00+00:00  47.988  49.744  46.668  47.908   164815.3\n",
       "...                           ...     ...     ...     ...        ...\n",
       "2023-03-01 10:30:00+00:00   6.912   6.963   6.909   6.953   953772.0\n",
       "2023-03-01 11:00:00+00:00   6.953   6.959   6.891   6.912   671234.7\n",
       "2023-03-01 11:30:00+00:00   6.913   6.981   6.900   6.946   832473.5\n",
       "2023-03-01 12:00:00+00:00   6.946   6.976   6.908   6.969  1109056.0\n",
       "2023-03-02 08:00:00+00:00   6.916   6.930   6.886   6.903   414231.8\n",
       "\n",
       "[7804 rows x 5 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.between_time('08:00','12:00')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "de8f9234",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 00:00:00+00:00</th>\n",
       "      <td>40.413444</td>\n",
       "      <td>41.518389</td>\n",
       "      <td>38.443361</td>\n",
       "      <td>39.568611</td>\n",
       "      <td>284927.961111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-17 00:00:00+00:00</th>\n",
       "      <td>32.215729</td>\n",
       "      <td>32.988833</td>\n",
       "      <td>31.550396</td>\n",
       "      <td>32.316729</td>\n",
       "      <td>143706.845833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-18 00:00:00+00:00</th>\n",
       "      <td>32.925271</td>\n",
       "      <td>33.328688</td>\n",
       "      <td>32.472250</td>\n",
       "      <td>32.864688</td>\n",
       "      <td>83203.068750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-19 00:00:00+00:00</th>\n",
       "      <td>28.610062</td>\n",
       "      <td>29.017750</td>\n",
       "      <td>28.153000</td>\n",
       "      <td>28.581417</td>\n",
       "      <td>150122.612500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-20 00:00:00+00:00</th>\n",
       "      <td>29.150833</td>\n",
       "      <td>29.429479</td>\n",
       "      <td>28.899729</td>\n",
       "      <td>29.145875</td>\n",
       "      <td>75243.670833</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Open       High        Low      Close  \\\n",
       "Datetime                                                                \n",
       "2020-10-16 00:00:00+00:00  40.413444  41.518389  38.443361  39.568611   \n",
       "2020-10-17 00:00:00+00:00  32.215729  32.988833  31.550396  32.316729   \n",
       "2020-10-18 00:00:00+00:00  32.925271  33.328688  32.472250  32.864688   \n",
       "2020-10-19 00:00:00+00:00  28.610062  29.017750  28.153000  28.581417   \n",
       "2020-10-20 00:00:00+00:00  29.150833  29.429479  28.899729  29.145875   \n",
       "\n",
       "                                  Volume  \n",
       "Datetime                                  \n",
       "2020-10-16 00:00:00+00:00  284927.961111  \n",
       "2020-10-17 00:00:00+00:00  143706.845833  \n",
       "2020-10-18 00:00:00+00:00   83203.068750  \n",
       "2020-10-19 00:00:00+00:00  150122.612500  \n",
       "2020-10-20 00:00:00+00:00   75243.670833  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.resample('D').mean().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "1c70a1a5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 00:00:00+00:00</th>\n",
       "      <td>60.455</td>\n",
       "      <td>60.462</td>\n",
       "      <td>55.855</td>\n",
       "      <td>57.399</td>\n",
       "      <td>859193.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-17 00:00:00+00:00</th>\n",
       "      <td>35.828</td>\n",
       "      <td>37.500</td>\n",
       "      <td>34.935</td>\n",
       "      <td>35.858</td>\n",
       "      <td>386733.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-18 00:00:00+00:00</th>\n",
       "      <td>35.041</td>\n",
       "      <td>35.590</td>\n",
       "      <td>34.751</td>\n",
       "      <td>35.023</td>\n",
       "      <td>309486.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-19 00:00:00+00:00</th>\n",
       "      <td>31.527</td>\n",
       "      <td>31.850</td>\n",
       "      <td>29.971</td>\n",
       "      <td>30.492</td>\n",
       "      <td>377238.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-20 00:00:00+00:00</th>\n",
       "      <td>30.025</td>\n",
       "      <td>30.500</td>\n",
       "      <td>29.644</td>\n",
       "      <td>29.940</td>\n",
       "      <td>254349.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Open    High     Low   Close    Volume\n",
       "Datetime                                                           \n",
       "2020-10-16 00:00:00+00:00  60.455  60.462  55.855  57.399  859193.0\n",
       "2020-10-17 00:00:00+00:00  35.828  37.500  34.935  35.858  386733.7\n",
       "2020-10-18 00:00:00+00:00  35.041  35.590  34.751  35.023  309486.9\n",
       "2020-10-19 00:00:00+00:00  31.527  31.850  29.971  30.492  377238.6\n",
       "2020-10-20 00:00:00+00:00  30.025  30.500  29.644  29.940  254349.6"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.resample('D').max().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "5dc01fb3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-10-16 00:00:00+00:00</th>\n",
       "      <td>34.709485</td>\n",
       "      <td>35.438659</td>\n",
       "      <td>33.765515</td>\n",
       "      <td>34.493773</td>\n",
       "      <td>160220.321970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-19 00:00:00+00:00</th>\n",
       "      <td>28.970306</td>\n",
       "      <td>29.280306</td>\n",
       "      <td>28.625014</td>\n",
       "      <td>28.935667</td>\n",
       "      <td>102769.550694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-22 00:00:00+00:00</th>\n",
       "      <td>23.624868</td>\n",
       "      <td>23.922701</td>\n",
       "      <td>23.302715</td>\n",
       "      <td>23.611597</td>\n",
       "      <td>164465.562500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-25 00:00:00+00:00</th>\n",
       "      <td>31.067292</td>\n",
       "      <td>31.695014</td>\n",
       "      <td>30.607410</td>\n",
       "      <td>31.138243</td>\n",
       "      <td>261159.311806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-28 00:00:00+00:00</th>\n",
       "      <td>32.183979</td>\n",
       "      <td>32.460132</td>\n",
       "      <td>31.858069</td>\n",
       "      <td>32.142806</td>\n",
       "      <td>109827.788889</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Open       High        Low      Close  \\\n",
       "Datetime                                                                \n",
       "2020-10-16 00:00:00+00:00  34.709485  35.438659  33.765515  34.493773   \n",
       "2020-10-19 00:00:00+00:00  28.970306  29.280306  28.625014  28.935667   \n",
       "2020-10-22 00:00:00+00:00  23.624868  23.922701  23.302715  23.611597   \n",
       "2020-10-25 00:00:00+00:00  31.067292  31.695014  30.607410  31.138243   \n",
       "2020-10-28 00:00:00+00:00  32.183979  32.460132  31.858069  32.142806   \n",
       "\n",
       "                                  Volume  \n",
       "Datetime                                  \n",
       "2020-10-16 00:00:00+00:00  160220.321970  \n",
       "2020-10-19 00:00:00+00:00  102769.550694  \n",
       "2020-10-22 00:00:00+00:00  164465.562500  \n",
       "2020-10-25 00:00:00+00:00  261159.311806  \n",
       "2020-10-28 00:00:00+00:00  109827.788889  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.resample('3D').mean().head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "ef4d856a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "/* Put everything inside the global mpl namespace */\n",
       "/* global mpl */\n",
       "window.mpl = {};\n",
       "\n",
       "mpl.get_websocket_type = function () {\n",
       "    if (typeof WebSocket !== 'undefined') {\n",
       "        return WebSocket;\n",
       "    } else if (typeof MozWebSocket !== 'undefined') {\n",
       "        return MozWebSocket;\n",
       "    } else {\n",
       "        alert(\n",
       "            'Your browser does not have WebSocket support. ' +\n",
       "                'Please try Chrome, Safari or Firefox ≥ 6. ' +\n",
       "                'Firefox 4 and 5 are also supported but you ' +\n",
       "                'have to enable WebSockets in about:config.'\n",
       "        );\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure = function (figure_id, websocket, ondownload, parent_element) {\n",
       "    this.id = figure_id;\n",
       "\n",
       "    this.ws = websocket;\n",
       "\n",
       "    this.supports_binary = this.ws.binaryType !== undefined;\n",
       "\n",
       "    if (!this.supports_binary) {\n",
       "        var warnings = document.getElementById('mpl-warnings');\n",
       "        if (warnings) {\n",
       "            warnings.style.display = 'block';\n",
       "            warnings.textContent =\n",
       "                'This browser does not support binary websocket messages. ' +\n",
       "                'Performance may be slow.';\n",
       "        }\n",
       "    }\n",
       "\n",
       "    this.imageObj = new Image();\n",
       "\n",
       "    this.context = undefined;\n",
       "    this.message = undefined;\n",
       "    this.canvas = undefined;\n",
       "    this.rubberband_canvas = undefined;\n",
       "    this.rubberband_context = undefined;\n",
       "    this.format_dropdown = undefined;\n",
       "\n",
       "    this.image_mode = 'full';\n",
       "\n",
       "    this.root = document.createElement('div');\n",
       "    this.root.setAttribute('style', 'display: inline-block');\n",
       "    this._root_extra_style(this.root);\n",
       "\n",
       "    parent_element.appendChild(this.root);\n",
       "\n",
       "    this._init_header(this);\n",
       "    this._init_canvas(this);\n",
       "    this._init_toolbar(this);\n",
       "\n",
       "    var fig = this;\n",
       "\n",
       "    this.waiting = false;\n",
       "\n",
       "    this.ws.onopen = function () {\n",
       "        fig.send_message('supports_binary', { value: fig.supports_binary });\n",
       "        fig.send_message('send_image_mode', {});\n",
       "        if (fig.ratio !== 1) {\n",
       "            fig.send_message('set_device_pixel_ratio', {\n",
       "                device_pixel_ratio: fig.ratio,\n",
       "            });\n",
       "        }\n",
       "        fig.send_message('refresh', {});\n",
       "    };\n",
       "\n",
       "    this.imageObj.onload = function () {\n",
       "        if (fig.image_mode === 'full') {\n",
       "            // Full images could contain transparency (where diff images\n",
       "            // almost always do), so we need to clear the canvas so that\n",
       "            // there is no ghosting.\n",
       "            fig.context.clearRect(0, 0, fig.canvas.width, fig.canvas.height);\n",
       "        }\n",
       "        fig.context.drawImage(fig.imageObj, 0, 0);\n",
       "    };\n",
       "\n",
       "    this.imageObj.onunload = function () {\n",
       "        fig.ws.close();\n",
       "    };\n",
       "\n",
       "    this.ws.onmessage = this._make_on_message_function(this);\n",
       "\n",
       "    this.ondownload = ondownload;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_header = function () {\n",
       "    var titlebar = document.createElement('div');\n",
       "    titlebar.classList =\n",
       "        'ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix';\n",
       "    var titletext = document.createElement('div');\n",
       "    titletext.classList = 'ui-dialog-title';\n",
       "    titletext.setAttribute(\n",
       "        'style',\n",
       "        'width: 100%; text-align: center; padding: 3px;'\n",
       "    );\n",
       "    titlebar.appendChild(titletext);\n",
       "    this.root.appendChild(titlebar);\n",
       "    this.header = titletext;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._canvas_extra_style = function (_canvas_div) {};\n",
       "\n",
       "mpl.figure.prototype._root_extra_style = function (_canvas_div) {};\n",
       "\n",
       "mpl.figure.prototype._init_canvas = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var canvas_div = (this.canvas_div = document.createElement('div'));\n",
       "    canvas_div.setAttribute('tabindex', '0');\n",
       "    canvas_div.setAttribute(\n",
       "        'style',\n",
       "        'border: 1px solid #ddd;' +\n",
       "            'box-sizing: content-box;' +\n",
       "            'clear: both;' +\n",
       "            'min-height: 1px;' +\n",
       "            'min-width: 1px;' +\n",
       "            'outline: 0;' +\n",
       "            'overflow: hidden;' +\n",
       "            'position: relative;' +\n",
       "            'resize: both;' +\n",
       "            'z-index: 2;'\n",
       "    );\n",
       "\n",
       "    function on_keyboard_event_closure(name) {\n",
       "        return function (event) {\n",
       "            return fig.key_event(event, name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    canvas_div.addEventListener(\n",
       "        'keydown',\n",
       "        on_keyboard_event_closure('key_press')\n",
       "    );\n",
       "    canvas_div.addEventListener(\n",
       "        'keyup',\n",
       "        on_keyboard_event_closure('key_release')\n",
       "    );\n",
       "\n",
       "    this._canvas_extra_style(canvas_div);\n",
       "    this.root.appendChild(canvas_div);\n",
       "\n",
       "    var canvas = (this.canvas = document.createElement('canvas'));\n",
       "    canvas.classList.add('mpl-canvas');\n",
       "    canvas.setAttribute(\n",
       "        'style',\n",
       "        'box-sizing: content-box;' +\n",
       "            'pointer-events: none;' +\n",
       "            'position: relative;' +\n",
       "            'z-index: 0;'\n",
       "    );\n",
       "\n",
       "    this.context = canvas.getContext('2d');\n",
       "\n",
       "    var backingStore =\n",
       "        this.context.backingStorePixelRatio ||\n",
       "        this.context.webkitBackingStorePixelRatio ||\n",
       "        this.context.mozBackingStorePixelRatio ||\n",
       "        this.context.msBackingStorePixelRatio ||\n",
       "        this.context.oBackingStorePixelRatio ||\n",
       "        this.context.backingStorePixelRatio ||\n",
       "        1;\n",
       "\n",
       "    this.ratio = (window.devicePixelRatio || 1) / backingStore;\n",
       "\n",
       "    var rubberband_canvas = (this.rubberband_canvas = document.createElement(\n",
       "        'canvas'\n",
       "    ));\n",
       "    rubberband_canvas.setAttribute(\n",
       "        'style',\n",
       "        'box-sizing: content-box;' +\n",
       "            'left: 0;' +\n",
       "            'pointer-events: none;' +\n",
       "            'position: absolute;' +\n",
       "            'top: 0;' +\n",
       "            'z-index: 1;'\n",
       "    );\n",
       "\n",
       "    // Apply a ponyfill if ResizeObserver is not implemented by browser.\n",
       "    if (this.ResizeObserver === undefined) {\n",
       "        if (window.ResizeObserver !== undefined) {\n",
       "            this.ResizeObserver = window.ResizeObserver;\n",
       "        } else {\n",
       "            var obs = _JSXTOOLS_RESIZE_OBSERVER({});\n",
       "            this.ResizeObserver = obs.ResizeObserver;\n",
       "        }\n",
       "    }\n",
       "\n",
       "    this.resizeObserverInstance = new this.ResizeObserver(function (entries) {\n",
       "        var nentries = entries.length;\n",
       "        for (var i = 0; i < nentries; i++) {\n",
       "            var entry = entries[i];\n",
       "            var width, height;\n",
       "            if (entry.contentBoxSize) {\n",
       "                if (entry.contentBoxSize instanceof Array) {\n",
       "                    // Chrome 84 implements new version of spec.\n",
       "                    width = entry.contentBoxSize[0].inlineSize;\n",
       "                    height = entry.contentBoxSize[0].blockSize;\n",
       "                } else {\n",
       "                    // Firefox implements old version of spec.\n",
       "                    width = entry.contentBoxSize.inlineSize;\n",
       "                    height = entry.contentBoxSize.blockSize;\n",
       "                }\n",
       "            } else {\n",
       "                // Chrome <84 implements even older version of spec.\n",
       "                width = entry.contentRect.width;\n",
       "                height = entry.contentRect.height;\n",
       "            }\n",
       "\n",
       "            // Keep the size of the canvas and rubber band canvas in sync with\n",
       "            // the canvas container.\n",
       "            if (entry.devicePixelContentBoxSize) {\n",
       "                // Chrome 84 implements new version of spec.\n",
       "                canvas.setAttribute(\n",
       "                    'width',\n",
       "                    entry.devicePixelContentBoxSize[0].inlineSize\n",
       "                );\n",
       "                canvas.setAttribute(\n",
       "                    'height',\n",
       "                    entry.devicePixelContentBoxSize[0].blockSize\n",
       "                );\n",
       "            } else {\n",
       "                canvas.setAttribute('width', width * fig.ratio);\n",
       "                canvas.setAttribute('height', height * fig.ratio);\n",
       "            }\n",
       "            /* This rescales the canvas back to display pixels, so that it\n",
       "             * appears correct on HiDPI screens. */\n",
       "            canvas.style.width = width + 'px';\n",
       "            canvas.style.height = height + 'px';\n",
       "\n",
       "            rubberband_canvas.setAttribute('width', width);\n",
       "            rubberband_canvas.setAttribute('height', height);\n",
       "\n",
       "            // And update the size in Python. We ignore the initial 0/0 size\n",
       "            // that occurs as the element is placed into the DOM, which should\n",
       "            // otherwise not happen due to the minimum size styling.\n",
       "            if (fig.ws.readyState == 1 && width != 0 && height != 0) {\n",
       "                fig.request_resize(width, height);\n",
       "            }\n",
       "        }\n",
       "    });\n",
       "    this.resizeObserverInstance.observe(canvas_div);\n",
       "\n",
       "    function on_mouse_event_closure(name) {\n",
       "        /* User Agent sniffing is bad, but WebKit is busted:\n",
       "         * https://bugs.webkit.org/show_bug.cgi?id=144526\n",
       "         * https://bugs.webkit.org/show_bug.cgi?id=181818\n",
       "         * The worst that happens here is that they get an extra browser\n",
       "         * selection when dragging, if this check fails to catch them.\n",
       "         */\n",
       "        var UA = navigator.userAgent;\n",
       "        var isWebKit = /AppleWebKit/.test(UA) && !/Chrome/.test(UA);\n",
       "        if(isWebKit) {\n",
       "            return function (event) {\n",
       "                /* This prevents the web browser from automatically changing to\n",
       "                 * the text insertion cursor when the button is pressed. We\n",
       "                 * want to control all of the cursor setting manually through\n",
       "                 * the 'cursor' event from matplotlib */\n",
       "                event.preventDefault()\n",
       "                return fig.mouse_event(event, name);\n",
       "            };\n",
       "        } else {\n",
       "            return function (event) {\n",
       "                return fig.mouse_event(event, name);\n",
       "            };\n",
       "        }\n",
       "    }\n",
       "\n",
       "    canvas_div.addEventListener(\n",
       "        'mousedown',\n",
       "        on_mouse_event_closure('button_press')\n",
       "    );\n",
       "    canvas_div.addEventListener(\n",
       "        'mouseup',\n",
       "        on_mouse_event_closure('button_release')\n",
       "    );\n",
       "    canvas_div.addEventListener(\n",
       "        'dblclick',\n",
       "        on_mouse_event_closure('dblclick')\n",
       "    );\n",
       "    // Throttle sequential mouse events to 1 every 20ms.\n",
       "    canvas_div.addEventListener(\n",
       "        'mousemove',\n",
       "        on_mouse_event_closure('motion_notify')\n",
       "    );\n",
       "\n",
       "    canvas_div.addEventListener(\n",
       "        'mouseenter',\n",
       "        on_mouse_event_closure('figure_enter')\n",
       "    );\n",
       "    canvas_div.addEventListener(\n",
       "        'mouseleave',\n",
       "        on_mouse_event_closure('figure_leave')\n",
       "    );\n",
       "\n",
       "    canvas_div.addEventListener('wheel', function (event) {\n",
       "        if (event.deltaY < 0) {\n",
       "            event.step = 1;\n",
       "        } else {\n",
       "            event.step = -1;\n",
       "        }\n",
       "        on_mouse_event_closure('scroll')(event);\n",
       "    });\n",
       "\n",
       "    canvas_div.appendChild(canvas);\n",
       "    canvas_div.appendChild(rubberband_canvas);\n",
       "\n",
       "    this.rubberband_context = rubberband_canvas.getContext('2d');\n",
       "    this.rubberband_context.strokeStyle = '#000000';\n",
       "\n",
       "    this._resize_canvas = function (width, height, forward) {\n",
       "        if (forward) {\n",
       "            canvas_div.style.width = width + 'px';\n",
       "            canvas_div.style.height = height + 'px';\n",
       "        }\n",
       "    };\n",
       "\n",
       "    // Disable right mouse context menu.\n",
       "    canvas_div.addEventListener('contextmenu', function (_e) {\n",
       "        event.preventDefault();\n",
       "        return false;\n",
       "    });\n",
       "\n",
       "    function set_focus() {\n",
       "        canvas.focus();\n",
       "        canvas_div.focus();\n",
       "    }\n",
       "\n",
       "    window.setTimeout(set_focus, 100);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_toolbar = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var toolbar = document.createElement('div');\n",
       "    toolbar.classList = 'mpl-toolbar';\n",
       "    this.root.appendChild(toolbar);\n",
       "\n",
       "    function on_click_closure(name) {\n",
       "        return function (_event) {\n",
       "            return fig.toolbar_button_onclick(name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    function on_mouseover_closure(tooltip) {\n",
       "        return function (event) {\n",
       "            if (!event.currentTarget.disabled) {\n",
       "                return fig.toolbar_button_onmouseover(tooltip);\n",
       "            }\n",
       "        };\n",
       "    }\n",
       "\n",
       "    fig.buttons = {};\n",
       "    var buttonGroup = document.createElement('div');\n",
       "    buttonGroup.classList = 'mpl-button-group';\n",
       "    for (var toolbar_ind in mpl.toolbar_items) {\n",
       "        var name = mpl.toolbar_items[toolbar_ind][0];\n",
       "        var tooltip = mpl.toolbar_items[toolbar_ind][1];\n",
       "        var image = mpl.toolbar_items[toolbar_ind][2];\n",
       "        var method_name = mpl.toolbar_items[toolbar_ind][3];\n",
       "\n",
       "        if (!name) {\n",
       "            /* Instead of a spacer, we start a new button group. */\n",
       "            if (buttonGroup.hasChildNodes()) {\n",
       "                toolbar.appendChild(buttonGroup);\n",
       "            }\n",
       "            buttonGroup = document.createElement('div');\n",
       "            buttonGroup.classList = 'mpl-button-group';\n",
       "            continue;\n",
       "        }\n",
       "\n",
       "        var button = (fig.buttons[name] = document.createElement('button'));\n",
       "        button.classList = 'mpl-widget';\n",
       "        button.setAttribute('role', 'button');\n",
       "        button.setAttribute('aria-disabled', 'false');\n",
       "        button.addEventListener('click', on_click_closure(method_name));\n",
       "        button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n",
       "\n",
       "        var icon_img = document.createElement('img');\n",
       "        icon_img.src = '_images/' + image + '.png';\n",
       "        icon_img.srcset = '_images/' + image + '_large.png 2x';\n",
       "        icon_img.alt = tooltip;\n",
       "        button.appendChild(icon_img);\n",
       "\n",
       "        buttonGroup.appendChild(button);\n",
       "    }\n",
       "\n",
       "    if (buttonGroup.hasChildNodes()) {\n",
       "        toolbar.appendChild(buttonGroup);\n",
       "    }\n",
       "\n",
       "    var fmt_picker = document.createElement('select');\n",
       "    fmt_picker.classList = 'mpl-widget';\n",
       "    toolbar.appendChild(fmt_picker);\n",
       "    this.format_dropdown = fmt_picker;\n",
       "\n",
       "    for (var ind in mpl.extensions) {\n",
       "        var fmt = mpl.extensions[ind];\n",
       "        var option = document.createElement('option');\n",
       "        option.selected = fmt === mpl.default_extension;\n",
       "        option.innerHTML = fmt;\n",
       "        fmt_picker.appendChild(option);\n",
       "    }\n",
       "\n",
       "    var status_bar = document.createElement('span');\n",
       "    status_bar.classList = 'mpl-message';\n",
       "    toolbar.appendChild(status_bar);\n",
       "    this.message = status_bar;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.request_resize = function (x_pixels, y_pixels) {\n",
       "    // Request matplotlib to resize the figure. Matplotlib will then trigger a resize in the client,\n",
       "    // which will in turn request a refresh of the image.\n",
       "    this.send_message('resize', { width: x_pixels, height: y_pixels });\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.send_message = function (type, properties) {\n",
       "    properties['type'] = type;\n",
       "    properties['figure_id'] = this.id;\n",
       "    this.ws.send(JSON.stringify(properties));\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.send_draw_message = function () {\n",
       "    if (!this.waiting) {\n",
       "        this.waiting = true;\n",
       "        this.ws.send(JSON.stringify({ type: 'draw', figure_id: this.id }));\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_save = function (fig, _msg) {\n",
       "    var format_dropdown = fig.format_dropdown;\n",
       "    var format = format_dropdown.options[format_dropdown.selectedIndex].value;\n",
       "    fig.ondownload(fig, format);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_resize = function (fig, msg) {\n",
       "    var size = msg['size'];\n",
       "    if (size[0] !== fig.canvas.width || size[1] !== fig.canvas.height) {\n",
       "        fig._resize_canvas(size[0], size[1], msg['forward']);\n",
       "        fig.send_message('refresh', {});\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_rubberband = function (fig, msg) {\n",
       "    var x0 = msg['x0'] / fig.ratio;\n",
       "    var y0 = (fig.canvas.height - msg['y0']) / fig.ratio;\n",
       "    var x1 = msg['x1'] / fig.ratio;\n",
       "    var y1 = (fig.canvas.height - msg['y1']) / fig.ratio;\n",
       "    x0 = Math.floor(x0) + 0.5;\n",
       "    y0 = Math.floor(y0) + 0.5;\n",
       "    x1 = Math.floor(x1) + 0.5;\n",
       "    y1 = Math.floor(y1) + 0.5;\n",
       "    var min_x = Math.min(x0, x1);\n",
       "    var min_y = Math.min(y0, y1);\n",
       "    var width = Math.abs(x1 - x0);\n",
       "    var height = Math.abs(y1 - y0);\n",
       "\n",
       "    fig.rubberband_context.clearRect(\n",
       "        0,\n",
       "        0,\n",
       "        fig.canvas.width / fig.ratio,\n",
       "        fig.canvas.height / fig.ratio\n",
       "    );\n",
       "\n",
       "    fig.rubberband_context.strokeRect(min_x, min_y, width, height);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_figure_label = function (fig, msg) {\n",
       "    // Updates the figure title.\n",
       "    fig.header.textContent = msg['label'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_cursor = function (fig, msg) {\n",
       "    fig.canvas_div.style.cursor = msg['cursor'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_message = function (fig, msg) {\n",
       "    fig.message.textContent = msg['message'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_draw = function (fig, _msg) {\n",
       "    // Request the server to send over a new figure.\n",
       "    fig.send_draw_message();\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_image_mode = function (fig, msg) {\n",
       "    fig.image_mode = msg['mode'];\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_history_buttons = function (fig, msg) {\n",
       "    for (var key in msg) {\n",
       "        if (!(key in fig.buttons)) {\n",
       "            continue;\n",
       "        }\n",
       "        fig.buttons[key].disabled = !msg[key];\n",
       "        fig.buttons[key].setAttribute('aria-disabled', !msg[key]);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_navigate_mode = function (fig, msg) {\n",
       "    if (msg['mode'] === 'PAN') {\n",
       "        fig.buttons['Pan'].classList.add('active');\n",
       "        fig.buttons['Zoom'].classList.remove('active');\n",
       "    } else if (msg['mode'] === 'ZOOM') {\n",
       "        fig.buttons['Pan'].classList.remove('active');\n",
       "        fig.buttons['Zoom'].classList.add('active');\n",
       "    } else {\n",
       "        fig.buttons['Pan'].classList.remove('active');\n",
       "        fig.buttons['Zoom'].classList.remove('active');\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.updated_canvas_event = function () {\n",
       "    // Called whenever the canvas gets updated.\n",
       "    this.send_message('ack', {});\n",
       "};\n",
       "\n",
       "// A function to construct a web socket function for onmessage handling.\n",
       "// Called in the figure constructor.\n",
       "mpl.figure.prototype._make_on_message_function = function (fig) {\n",
       "    return function socket_on_message(evt) {\n",
       "        if (evt.data instanceof Blob) {\n",
       "            var img = evt.data;\n",
       "            if (img.type !== 'image/png') {\n",
       "                /* FIXME: We get \"Resource interpreted as Image but\n",
       "                 * transferred with MIME type text/plain:\" errors on\n",
       "                 * Chrome.  But how to set the MIME type?  It doesn't seem\n",
       "                 * to be part of the websocket stream */\n",
       "                img.type = 'image/png';\n",
       "            }\n",
       "\n",
       "            /* Free the memory for the previous frames */\n",
       "            if (fig.imageObj.src) {\n",
       "                (window.URL || window.webkitURL).revokeObjectURL(\n",
       "                    fig.imageObj.src\n",
       "                );\n",
       "            }\n",
       "\n",
       "            fig.imageObj.src = (window.URL || window.webkitURL).createObjectURL(\n",
       "                img\n",
       "            );\n",
       "            fig.updated_canvas_event();\n",
       "            fig.waiting = false;\n",
       "            return;\n",
       "        } else if (\n",
       "            typeof evt.data === 'string' &&\n",
       "            evt.data.slice(0, 21) === 'data:image/png;base64'\n",
       "        ) {\n",
       "            fig.imageObj.src = evt.data;\n",
       "            fig.updated_canvas_event();\n",
       "            fig.waiting = false;\n",
       "            return;\n",
       "        }\n",
       "\n",
       "        var msg = JSON.parse(evt.data);\n",
       "        var msg_type = msg['type'];\n",
       "\n",
       "        // Call the  \"handle_{type}\" callback, which takes\n",
       "        // the figure and JSON message as its only arguments.\n",
       "        try {\n",
       "            var callback = fig['handle_' + msg_type];\n",
       "        } catch (e) {\n",
       "            console.log(\n",
       "                \"No handler for the '\" + msg_type + \"' message type: \",\n",
       "                msg\n",
       "            );\n",
       "            return;\n",
       "        }\n",
       "\n",
       "        if (callback) {\n",
       "            try {\n",
       "                // console.log(\"Handling '\" + msg_type + \"' message: \", msg);\n",
       "                callback(fig, msg);\n",
       "            } catch (e) {\n",
       "                console.log(\n",
       "                    \"Exception inside the 'handler_\" + msg_type + \"' callback:\",\n",
       "                    e,\n",
       "                    e.stack,\n",
       "                    msg\n",
       "                );\n",
       "            }\n",
       "        }\n",
       "    };\n",
       "};\n",
       "\n",
       "function getModifiers(event) {\n",
       "    var mods = [];\n",
       "    if (event.ctrlKey) {\n",
       "        mods.push('ctrl');\n",
       "    }\n",
       "    if (event.altKey) {\n",
       "        mods.push('alt');\n",
       "    }\n",
       "    if (event.shiftKey) {\n",
       "        mods.push('shift');\n",
       "    }\n",
       "    if (event.metaKey) {\n",
       "        mods.push('meta');\n",
       "    }\n",
       "    return mods;\n",
       "}\n",
       "\n",
       "/*\n",
       " * return a copy of an object with only non-object keys\n",
       " * we need this to avoid circular references\n",
       " * https://stackoverflow.com/a/24161582/3208463\n",
       " */\n",
       "function simpleKeys(original) {\n",
       "    return Object.keys(original).reduce(function (obj, key) {\n",
       "        if (typeof original[key] !== 'object') {\n",
       "            obj[key] = original[key];\n",
       "        }\n",
       "        return obj;\n",
       "    }, {});\n",
       "}\n",
       "\n",
       "mpl.figure.prototype.mouse_event = function (event, name) {\n",
       "    if (name === 'button_press') {\n",
       "        this.canvas.focus();\n",
       "        this.canvas_div.focus();\n",
       "    }\n",
       "\n",
       "    // from https://stackoverflow.com/q/1114465\n",
       "    var boundingRect = this.canvas.getBoundingClientRect();\n",
       "    var x = (event.clientX - boundingRect.left) * this.ratio;\n",
       "    var y = (event.clientY - boundingRect.top) * this.ratio;\n",
       "\n",
       "    this.send_message(name, {\n",
       "        x: x,\n",
       "        y: y,\n",
       "        button: event.button,\n",
       "        step: event.step,\n",
       "        modifiers: getModifiers(event),\n",
       "        guiEvent: simpleKeys(event),\n",
       "    });\n",
       "\n",
       "    return false;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._key_event_extra = function (_event, _name) {\n",
       "    // Handle any extra behaviour associated with a key event\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.key_event = function (event, name) {\n",
       "    // Prevent repeat events\n",
       "    if (name === 'key_press') {\n",
       "        if (event.key === this._key) {\n",
       "            return;\n",
       "        } else {\n",
       "            this._key = event.key;\n",
       "        }\n",
       "    }\n",
       "    if (name === 'key_release') {\n",
       "        this._key = null;\n",
       "    }\n",
       "\n",
       "    var value = '';\n",
       "    if (event.ctrlKey && event.key !== 'Control') {\n",
       "        value += 'ctrl+';\n",
       "    }\n",
       "    else if (event.altKey && event.key !== 'Alt') {\n",
       "        value += 'alt+';\n",
       "    }\n",
       "    else if (event.shiftKey && event.key !== 'Shift') {\n",
       "        value += 'shift+';\n",
       "    }\n",
       "\n",
       "    value += 'k' + event.key;\n",
       "\n",
       "    this._key_event_extra(event, name);\n",
       "\n",
       "    this.send_message(name, { key: value, guiEvent: simpleKeys(event) });\n",
       "    return false;\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.toolbar_button_onclick = function (name) {\n",
       "    if (name === 'download') {\n",
       "        this.handle_save(this, null);\n",
       "    } else {\n",
       "        this.send_message('toolbar_button', { name: name });\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.toolbar_button_onmouseover = function (tooltip) {\n",
       "    this.message.textContent = tooltip;\n",
       "};\n",
       "\n",
       "///////////////// REMAINING CONTENT GENERATED BY embed_js.py /////////////////\n",
       "// prettier-ignore\n",
       "var _JSXTOOLS_RESIZE_OBSERVER=function(A){var t,i=new WeakMap,n=new WeakMap,a=new WeakMap,r=new WeakMap,o=new Set;function s(e){if(!(this instanceof s))throw new TypeError(\"Constructor requires 'new' operator\");i.set(this,e)}function h(){throw new TypeError(\"Function is not a constructor\")}function c(e,t,i,n){e=0 in arguments?Number(arguments[0]):0,t=1 in arguments?Number(arguments[1]):0,i=2 in arguments?Number(arguments[2]):0,n=3 in arguments?Number(arguments[3]):0,this.right=(this.x=this.left=e)+(this.width=i),this.bottom=(this.y=this.top=t)+(this.height=n),Object.freeze(this)}function d(){t=requestAnimationFrame(d);var s=new WeakMap,p=new Set;o.forEach((function(t){r.get(t).forEach((function(i){var r=t instanceof window.SVGElement,o=a.get(t),d=r?0:parseFloat(o.paddingTop),f=r?0:parseFloat(o.paddingRight),l=r?0:parseFloat(o.paddingBottom),u=r?0:parseFloat(o.paddingLeft),g=r?0:parseFloat(o.borderTopWidth),m=r?0:parseFloat(o.borderRightWidth),w=r?0:parseFloat(o.borderBottomWidth),b=u+f,F=d+l,v=(r?0:parseFloat(o.borderLeftWidth))+m,W=g+w,y=r?0:t.offsetHeight-W-t.clientHeight,E=r?0:t.offsetWidth-v-t.clientWidth,R=b+v,z=F+W,M=r?t.width:parseFloat(o.width)-R-E,O=r?t.height:parseFloat(o.height)-z-y;if(n.has(t)){var k=n.get(t);if(k[0]===M&&k[1]===O)return}n.set(t,[M,O]);var S=Object.create(h.prototype);S.target=t,S.contentRect=new c(u,d,M,O),s.has(i)||(s.set(i,[]),p.add(i)),s.get(i).push(S)}))})),p.forEach((function(e){i.get(e).call(e,s.get(e),e)}))}return s.prototype.observe=function(i){if(i instanceof window.Element){r.has(i)||(r.set(i,new Set),o.add(i),a.set(i,window.getComputedStyle(i)));var n=r.get(i);n.has(this)||n.add(this),cancelAnimationFrame(t),t=requestAnimationFrame(d)}},s.prototype.unobserve=function(i){if(i instanceof window.Element&&r.has(i)){var n=r.get(i);n.has(this)&&(n.delete(this),n.size||(r.delete(i),o.delete(i))),n.size||r.delete(i),o.size||cancelAnimationFrame(t)}},A.DOMRectReadOnly=c,A.ResizeObserver=s,A.ResizeObserverEntry=h,A}; // eslint-disable-line\n",
       "mpl.toolbar_items = [[\"Home\", \"Reset original view\", \"fa fa-home\", \"home\"], [\"Back\", \"Back to previous view\", \"fa fa-arrow-left\", \"back\"], [\"Forward\", \"Forward to next view\", \"fa fa-arrow-right\", \"forward\"], [\"\", \"\", \"\", \"\"], [\"Pan\", \"Left button pans, Right button zooms\\nx/y fixes axis, CTRL fixes aspect\", \"fa fa-arrows\", \"pan\"], [\"Zoom\", \"Zoom to rectangle\\nx/y fixes axis\", \"fa fa-square-o\", \"zoom\"], [\"\", \"\", \"\", \"\"], [\"Download\", \"Download plot\", \"fa fa-floppy-o\", \"download\"]];\n",
       "\n",
       "mpl.extensions = [\"eps\", \"jpeg\", \"pgf\", \"pdf\", \"png\", \"ps\", \"raw\", \"svg\", \"tif\", \"webp\"];\n",
       "\n",
       "mpl.default_extension = \"png\";/* global mpl */\n",
       "\n",
       "var comm_websocket_adapter = function (comm) {\n",
       "    // Create a \"websocket\"-like object which calls the given IPython comm\n",
       "    // object with the appropriate methods. Currently this is a non binary\n",
       "    // socket, so there is still some room for performance tuning.\n",
       "    var ws = {};\n",
       "\n",
       "    ws.binaryType = comm.kernel.ws.binaryType;\n",
       "    ws.readyState = comm.kernel.ws.readyState;\n",
       "    function updateReadyState(_event) {\n",
       "        if (comm.kernel.ws) {\n",
       "            ws.readyState = comm.kernel.ws.readyState;\n",
       "        } else {\n",
       "            ws.readyState = 3; // Closed state.\n",
       "        }\n",
       "    }\n",
       "    comm.kernel.ws.addEventListener('open', updateReadyState);\n",
       "    comm.kernel.ws.addEventListener('close', updateReadyState);\n",
       "    comm.kernel.ws.addEventListener('error', updateReadyState);\n",
       "\n",
       "    ws.close = function () {\n",
       "        comm.close();\n",
       "    };\n",
       "    ws.send = function (m) {\n",
       "        //console.log('sending', m);\n",
       "        comm.send(m);\n",
       "    };\n",
       "    // Register the callback with on_msg.\n",
       "    comm.on_msg(function (msg) {\n",
       "        //console.log('receiving', msg['content']['data'], msg);\n",
       "        var data = msg['content']['data'];\n",
       "        if (data['blob'] !== undefined) {\n",
       "            data = {\n",
       "                data: new Blob(msg['buffers'], { type: data['blob'] }),\n",
       "            };\n",
       "        }\n",
       "        // Pass the mpl event to the overridden (by mpl) onmessage function.\n",
       "        ws.onmessage(data);\n",
       "    });\n",
       "    return ws;\n",
       "};\n",
       "\n",
       "mpl.mpl_figure_comm = function (comm, msg) {\n",
       "    // This is the function which gets called when the mpl process\n",
       "    // starts-up an IPython Comm through the \"matplotlib\" channel.\n",
       "\n",
       "    var id = msg.content.data.id;\n",
       "    // Get hold of the div created by the display call when the Comm\n",
       "    // socket was opened in Python.\n",
       "    var element = document.getElementById(id);\n",
       "    var ws_proxy = comm_websocket_adapter(comm);\n",
       "\n",
       "    function ondownload(figure, _format) {\n",
       "        window.open(figure.canvas.toDataURL());\n",
       "    }\n",
       "\n",
       "    var fig = new mpl.figure(id, ws_proxy, ondownload, element);\n",
       "\n",
       "    // Call onopen now - mpl needs it, as it is assuming we've passed it a real\n",
       "    // web socket which is closed, not our websocket->open comm proxy.\n",
       "    ws_proxy.onopen();\n",
       "\n",
       "    fig.parent_element = element;\n",
       "    fig.cell_info = mpl.find_output_cell(\"<div id='\" + id + \"'></div>\");\n",
       "    if (!fig.cell_info) {\n",
       "        console.error('Failed to find cell for figure', id, fig);\n",
       "        return;\n",
       "    }\n",
       "    fig.cell_info[0].output_area.element.on(\n",
       "        'cleared',\n",
       "        { fig: fig },\n",
       "        fig._remove_fig_handler\n",
       "    );\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_close = function (fig, msg) {\n",
       "    var width = fig.canvas.width / fig.ratio;\n",
       "    fig.cell_info[0].output_area.element.off(\n",
       "        'cleared',\n",
       "        fig._remove_fig_handler\n",
       "    );\n",
       "    fig.resizeObserverInstance.unobserve(fig.canvas_div);\n",
       "\n",
       "    // Update the output cell to use the data from the current canvas.\n",
       "    fig.push_to_output();\n",
       "    var dataURL = fig.canvas.toDataURL();\n",
       "    // Re-enable the keyboard manager in IPython - without this line, in FF,\n",
       "    // the notebook keyboard shortcuts fail.\n",
       "    IPython.keyboard_manager.enable();\n",
       "    fig.parent_element.innerHTML =\n",
       "        '<img src=\"' + dataURL + '\" width=\"' + width + '\">';\n",
       "    fig.close_ws(fig, msg);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.close_ws = function (fig, msg) {\n",
       "    fig.send_message('closing', msg);\n",
       "    // fig.ws.close()\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.push_to_output = function (_remove_interactive) {\n",
       "    // Turn the data on the canvas into data in the output cell.\n",
       "    var width = this.canvas.width / this.ratio;\n",
       "    var dataURL = this.canvas.toDataURL();\n",
       "    this.cell_info[1]['text/html'] =\n",
       "        '<img src=\"' + dataURL + '\" width=\"' + width + '\">';\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.updated_canvas_event = function () {\n",
       "    // Tell IPython that the notebook contents must change.\n",
       "    IPython.notebook.set_dirty(true);\n",
       "    this.send_message('ack', {});\n",
       "    var fig = this;\n",
       "    // Wait a second, then push the new image to the DOM so\n",
       "    // that it is saved nicely (might be nice to debounce this).\n",
       "    setTimeout(function () {\n",
       "        fig.push_to_output();\n",
       "    }, 1000);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._init_toolbar = function () {\n",
       "    var fig = this;\n",
       "\n",
       "    var toolbar = document.createElement('div');\n",
       "    toolbar.classList = 'btn-toolbar';\n",
       "    this.root.appendChild(toolbar);\n",
       "\n",
       "    function on_click_closure(name) {\n",
       "        return function (_event) {\n",
       "            return fig.toolbar_button_onclick(name);\n",
       "        };\n",
       "    }\n",
       "\n",
       "    function on_mouseover_closure(tooltip) {\n",
       "        return function (event) {\n",
       "            if (!event.currentTarget.disabled) {\n",
       "                return fig.toolbar_button_onmouseover(tooltip);\n",
       "            }\n",
       "        };\n",
       "    }\n",
       "\n",
       "    fig.buttons = {};\n",
       "    var buttonGroup = document.createElement('div');\n",
       "    buttonGroup.classList = 'btn-group';\n",
       "    var button;\n",
       "    for (var toolbar_ind in mpl.toolbar_items) {\n",
       "        var name = mpl.toolbar_items[toolbar_ind][0];\n",
       "        var tooltip = mpl.toolbar_items[toolbar_ind][1];\n",
       "        var image = mpl.toolbar_items[toolbar_ind][2];\n",
       "        var method_name = mpl.toolbar_items[toolbar_ind][3];\n",
       "\n",
       "        if (!name) {\n",
       "            /* Instead of a spacer, we start a new button group. */\n",
       "            if (buttonGroup.hasChildNodes()) {\n",
       "                toolbar.appendChild(buttonGroup);\n",
       "            }\n",
       "            buttonGroup = document.createElement('div');\n",
       "            buttonGroup.classList = 'btn-group';\n",
       "            continue;\n",
       "        }\n",
       "\n",
       "        button = fig.buttons[name] = document.createElement('button');\n",
       "        button.classList = 'btn btn-default';\n",
       "        button.href = '#';\n",
       "        button.title = name;\n",
       "        button.innerHTML = '<i class=\"fa ' + image + ' fa-lg\"></i>';\n",
       "        button.addEventListener('click', on_click_closure(method_name));\n",
       "        button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n",
       "        buttonGroup.appendChild(button);\n",
       "    }\n",
       "\n",
       "    if (buttonGroup.hasChildNodes()) {\n",
       "        toolbar.appendChild(buttonGroup);\n",
       "    }\n",
       "\n",
       "    // Add the status bar.\n",
       "    var status_bar = document.createElement('span');\n",
       "    status_bar.classList = 'mpl-message pull-right';\n",
       "    toolbar.appendChild(status_bar);\n",
       "    this.message = status_bar;\n",
       "\n",
       "    // Add the close button to the window.\n",
       "    var buttongrp = document.createElement('div');\n",
       "    buttongrp.classList = 'btn-group inline pull-right';\n",
       "    button = document.createElement('button');\n",
       "    button.classList = 'btn btn-mini btn-primary';\n",
       "    button.href = '#';\n",
       "    button.title = 'Stop Interaction';\n",
       "    button.innerHTML = '<i class=\"fa fa-power-off icon-remove icon-large\"></i>';\n",
       "    button.addEventListener('click', function (_evt) {\n",
       "        fig.handle_close(fig, {});\n",
       "    });\n",
       "    button.addEventListener(\n",
       "        'mouseover',\n",
       "        on_mouseover_closure('Stop Interaction')\n",
       "    );\n",
       "    buttongrp.appendChild(button);\n",
       "    var titlebar = this.root.querySelector('.ui-dialog-titlebar');\n",
       "    titlebar.insertBefore(buttongrp, titlebar.firstChild);\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._remove_fig_handler = function (event) {\n",
       "    var fig = event.data.fig;\n",
       "    if (event.target !== this) {\n",
       "        // Ignore bubbled events from children.\n",
       "        return;\n",
       "    }\n",
       "    fig.close_ws(fig, {});\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._root_extra_style = function (el) {\n",
       "    el.style.boxSizing = 'content-box'; // override notebook setting of border-box.\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._canvas_extra_style = function (el) {\n",
       "    // this is important to make the div 'focusable\n",
       "    el.setAttribute('tabindex', 0);\n",
       "    // reach out to IPython and tell the keyboard manager to turn it's self\n",
       "    // off when our div gets focus\n",
       "\n",
       "    // location in version 3\n",
       "    if (IPython.notebook.keyboard_manager) {\n",
       "        IPython.notebook.keyboard_manager.register_events(el);\n",
       "    } else {\n",
       "        // location in version 2\n",
       "        IPython.keyboard_manager.register_events(el);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype._key_event_extra = function (event, _name) {\n",
       "    // Check for shift+enter\n",
       "    if (event.shiftKey && event.which === 13) {\n",
       "        this.canvas_div.blur();\n",
       "        // select the cell after this one\n",
       "        var index = IPython.notebook.find_cell_index(this.cell_info[0]);\n",
       "        IPython.notebook.select(index + 1);\n",
       "    }\n",
       "};\n",
       "\n",
       "mpl.figure.prototype.handle_save = function (fig, _msg) {\n",
       "    fig.ondownload(fig, null);\n",
       "};\n",
       "\n",
       "mpl.find_output_cell = function (html_output) {\n",
       "    // Return the cell and output element which can be found *uniquely* in the notebook.\n",
       "    // Note - this is a bit hacky, but it is done because the \"notebook_saving.Notebook\"\n",
       "    // IPython event is triggered only after the cells have been serialised, which for\n",
       "    // our purposes (turning an active figure into a static one), is too late.\n",
       "    var cells = IPython.notebook.get_cells();\n",
       "    var ncells = cells.length;\n",
       "    for (var i = 0; i < ncells; i++) {\n",
       "        var cell = cells[i];\n",
       "        if (cell.cell_type === 'code') {\n",
       "            for (var j = 0; j < cell.output_area.outputs.length; j++) {\n",
       "                var data = cell.output_area.outputs[j];\n",
       "                if (data.data) {\n",
       "                    // IPython >= 3 moved mimebundle to data attribute of output\n",
       "                    data = data.data;\n",
       "                }\n",
       "                if (data['text/html'] === html_output) {\n",
       "                    return [cell, data, j];\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    }\n",
       "};\n",
       "\n",
       "// Register the function which deals with the matplotlib target/channel.\n",
       "// The kernel may be null if the page has been refreshed.\n",
       "if (IPython.notebook.kernel !== null) {\n",
       "    IPython.notebook.kernel.comm_manager.register_target(\n",
       "        'matplotlib',\n",
       "        mpl.mpl_figure_comm\n",
       "    );\n",
       "}\n"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<img src=\"\" width=\"640\">"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<Axes: xlabel='Datetime'>"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.resample('M').mean().plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d4eb52f6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
